package com.dao;

import com.mypg.Info;
import org.apache.ibatis.annotations.Param;

import java.sql.Timestamp;
import java.util.List;

public interface InfoDao {
    List<Info> selectAllinfo();
    Info selectInfoByinfo_id(@Param("info_id") int info_id);
    List<Info> selectInfoForinfo_table_jsp(@Param("info_class")String info_class, @Param("time_start")Timestamp start,
                                           @Param("time_end")Timestamp end,@Param("start_row")int start_row,
                                           @Param("page_nums")int page_nums);
    List<Info> selectInfoByInfo_class(@Param("info_class")String info_class,@Param("other_class")String other_class);
    int selectInfo_count();
    int selectInfo_count_plus(@Param("info_class")String info_class, @Param("time_start")Timestamp start,
                              @Param("time_end")Timestamp end);

    void insertInfo(Info info);

    void deleteInfoByinfo_id(@Param("info_id") int info_id);

    void updateInfoByinfo_id(Info info);
    void updateInfo_readByInfo_id(@Param("info_id")int info_id);
}
